From eda6a454362279717f9fba18d42fe5cdb741610a Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Sat, 23 Jan 2021 14:26:05 -0600 Subject: [PATCH] Have literal_column_headings values be those of boolean_choice --- examples/etc/pgwui.ini | 15 +++++++++------ examples/misc/development.ini | 17 ++++++++++------- 2 files changed, 19 insertions(+), 13 deletions(-) diff --git a/examples/etc/pgwui.ini b/examples/etc/pgwui.ini index 1dae897..b174014 100644 --- a/examples/etc/pgwui.ini +++ b/examples/etc/pgwui.ini @@ -217,10 +217,13 @@ pgwui.dry_run = False # literal_column_headings # Take uploaded column headings literally? # The available choices are: -# on The file's column headings, as typed, are the table's column names. -# off The file's column headings are case-insensitive. -# ask Put a "Take Column Headings Literally" checkbox on the upload screen. -# Optional setting. The default is "off". +# yes-always The file's column headings, as typed, are the table's +# column names. +# choice-yes Present a checkbox, default to "yes". +# choice-no Present a checkbox, default to "no". +# no-never The file's column headings are given to PostgreSQL as-is, +# and so PostgreSQL normalizes them to lower case. +# Optional setting. The default is "no-never". # # Caution: Non-ASCII column names, particularly in the Turkish locale, # are not guaranteed to be case-insensitive. @@ -239,12 +242,12 @@ pgwui.dry_run = False # pgwui_bulk_upload #pgwui.pgwui_bulk_upload = -# literal_column_headings = off +# literal_column_headings = no-never # menu_label = bulk_upload -- Upload Many Files Into PostgreSQL # map_file = contents.yml # trim = choice-yes # -# literal_column_headings = off +# literal_column_headings = no-never # Take uploaded column headings literally? # See pgwui_upload above for details. # diff --git a/examples/misc/development.ini b/examples/misc/development.ini index b976446..684a49f 100644 --- a/examples/misc/development.ini +++ b/examples/misc/development.ini @@ -215,17 +215,20 @@ pgwui.validate_hmac = False # pgwui_upload #pgwui.pgwui_upload = -# literal_column_headings = off +# literal_column_headings = no-never # menu_label = upload -- Upload File Into Database # trim = choice-yes # # literal_column_headings # Take uploaded column headings literally? # The available choices are: -# on The file's column headings, as typed, are the table's column names. -# off The file's column headings are case-insensitive. -# ask Put a "Take Column Headings Literally" checkbox on the upload screen. -# Optional setting. The default is "off". +# yes-always The file's column headings, as typed, are the table's +# column names. +# choice-yes Present a checkbox, default to "yes". +# choice-no Present a checkbox, default to "no". +# no-never The file's column headings are given to PostgreSQL as-is, +# and so PostgreSQL normalizes them to lower case. +# Optional setting. The default is "no-never". # # Caution: Non-ASCII column names, particularly in the Turkish locale, # are not guaranteed to be case-insensitive. @@ -244,12 +247,12 @@ pgwui.validate_hmac = False # pgwui_bulk_upload #pgwui.pgwui_bulk_upload = -# literal_column_headings = off +# literal_column_headings = no-never # menu_label = bulk_upload -- Upload Many Files Into PostgreSQL # map_file = contents.yml # trim = choice-yes # -# literal_column_headings = off +# literal_column_headings = no-never # Take uploaded column headings literally? # See pgwui_upload above for details. # -- 2.34.1